To format data for import
The transaction format is tab- or comma-delimited input, with various types of records allowed in a single stream. The import file must contain a single batch header record, followed by any number of cash payment records.
Note: You cannot use the Dues Importer for accrual Dues billing cycle. You must use the AR Importer for accrual dues billing. To use the AR Importer, the System field (third field) under the Cash Payment Record should be AR. Make sure to insert the Invoice Number (sixth field) under the Cash Payment Record.
The major transaction formats include the following:
All Records
|
Field Name |
Data |
Comments |
1 |
Record Type |
|
Identifies the type of record |
2 |
Batch Number |
10 chars, all upper case |
|
Batch Header
|
Field Name |
Data |
Comments |
1 |
Record Type |
BH |
Always "BH" |
2 |
Batch Number |
10 chars, all upper case |
|
3 |
Batch Date |
Date |
Date of batch |
4 |
Batch Description |
60 chars |
|
5 |
Control Count |
Numeric |
Optional |
6 |
Control Amount |
Monetary |
Total of the batch of payments |
7 |
Cash Account Code |
10 chars, all upper case |
Code assigned through AR/Cash> Set up tables > Cash accounts; indicates the cash account where the funds were deposited |
Cash Payment Record
? |
Field Name |
Data |
Comments |
1 |
Record Type |
PAY |
Always "PAY" |
2 |
Batch Number |
10 chars, all upper case |
Optional; if blank, defaults to batch header's batch number |
3 |
System |
DUES |
|
4 |
Member ID |
10 chars, customer ID |
Can substitute Major Key, if prefixed with * (asterisk) |
5 |
Date |
Date |
Optional; if blank, defaults to batch header date |
6 |
Invoice |
Numeric |
Optional; payments can be applied to specific Product Codes by including the Product Code in this field |
7 |
Amount |
Individual payment amount |
Total amount of the check or credit card payment |
8 |
Check/CCType |
Check # or credit card type |
Optional |
9 |
CCNumber |
Credit card # |
Optional |
10 |
CCExp |
Credit card exp |
Optional |
11 |
Name On CC |
Name on credit card |
Optional |
12 |
CCAuthorize |
Credit card authorization code |
Optional |
13 |
Name |
60 chars for audit trail |
Optional but important. Will print on the transaction report to identify the customer/subscriber. |
14 |
Comment |
255 chars |
Optional but important. Will print on the transaction report and related inquiries to explain the transaction, such as "Dues Payment" or "Subscription Payment." |
10.5 Production Release. Updated 2/24/2006 11:15:48 AM
Copyright © by Advanced Solutions International, Inc.
All rights reserved.